﻿<?xml version="1.0" encoding="utf-8" ?>
<AppTable Name="Lead">
  <Field Name="LeadNo" DataType="text" Length="10" AutoGen="true" IsPrimary="true"></Field>
  <Field Name="Saluation" DataType="select" Options="Mr.,Ms.,Mrs." Length="30"></Field>
  <Field Name="FirstName" DataType="text" Length="50"></Field>
  <Field Name="LastName" DataType="text" Length="50"></Field>
  <Field Name="Company" DataType="text" Length="100"></Field>
  <Field Name="Title" DataType="text" Length="100"></Field>
  <Field Name="LeadSource" DataType="select" Options="Cold Call,Existing customer,Self generated,Employee,Partner,Public Relations" Length="30"></Field>
  <Field Name="Industry" DataType="select" Options="Apparel,Banking,Biotechnology,Chemicals,Communications,Construction,Consulting,Education" Length="30"></Field>
  <Field Name="AnnualRevenue" DataType="decimal" Length="18"></Field>
  <Field Name="NoOfEmployee" DataType="text" Length="50"></Field>
  <Field Name="SecondaryEmail" DataType="text" Length="100"></Field>
  <Field Name="Phone" DataType="text" Length="20"></Field>
  <Field Name="Mobile" DataType="text" Length="20"></Field>
  <Field Name="Fax" DataType="text" Length="20"></Field>
  <Field Name="Email" DataType="text" Length="20"></Field>
  <Field Name="Website" DataType="text" Length="20"></Field>
  <Field Name="LeadStatus" DataType="select" Options="Attempted to contact,Cold,Warm,Junk,Lost" Length="30"></Field>
  <Field Name="AssignedUser" DataType="selecttable" LinkTable="User" DisplayField="FirstName + ' ' + LastName" StoreField="UserID" Length="30"></Field>
  <Field Name="AssignedGroup" DataType="selecttable" LinkTable="User" DisplayField="FirstName + ' ' + LastName" StoreField="UserID" Length="30"></Field>
  <Field Name="Street" DataType="text" Length="400"></Field>
  <Field Name="POBox" DataType="text" Length="100"></Field>
  <Field Name="State" DataType="text" Length="50"></Field>
  <Field Name="Country" DataType="text" Length="50"></Field>
  <Field Name="PostalCode" DataType="text" Length="10"></Field>
  <Field Name="MoreInformation" DataType="text" Length="1000"></Field>
</AppTable>

